﻿

-- 人员班次信息增加
create procedure [dbo].[BcInfo_Add]
@bcm varchar(50),
@sjd1ks varchar(6),
@sjd1js varchar(6),
@sjd2ks varchar(6)=null,
@sjd2js varchar(6)=null,
@sjd3ks varchar(6)=null,
@sjd3js varchar(6)=null,
@sjd4ks varchar(6)=null,
@sjd4js varchar(6)=null
as
insert into Bc_Info(bcm,sjd1ks,sjd1js,sjd2ks,sjd2js,sjd3ks,sjd3js,sjd4ks,sjd4js)
values
(@bcm,@sjd1ks,@sjd1js,@sjd2ks,@sjd2js,@sjd3ks,@sjd3js,@sjd4ks,@sjd4js)
select @@identity